JD Edwards Data Mapping Table

The JD Edwards data mapping table lists the fields that are imported from JD Edwards to Time and Expense.

The following information shows the mapping for the JDEdwards table (JDE_TS_F5606ZW):

Field Size Source Notes
WKC5606EMP CHAR (20) EXPORT_LABOR.empl_id The unique identifier of the employee.
WKC5606TS CHAR (10) EXPORT_LABOR.ts_schedule_cd The timesheet frequency identifier.
WKC5606FYR CHAR (4) EXPORT_LABOR.year_no_cd The timesheet frequency's year code.
WKC5606PER CHAR (3) EXPORT_LABOR.period_no_cd The period number for the timesheet frequency.
WKEDLN FLOAT (126) EXPORT_LABOR.line_no The timesheet line number to which the timesheet cell record belongs.
WKC5606CDT CHAR (10) EXPORT_LABOR.hrs_dt The column (cell) date for this row.
WKC5606SDT CHAR (10) TS_SCHEDULE_PERIOD.start_dt based on EXPORT_LABOR.ts_schedule_cd and EXPORT_LABOR.year_no_cd and EXPORT_LABOR.period_no_cd The start date of the period.

Converted to String yyyy-mm-dd.

WKC5606EDT CHAR (10) TS_SCHEDULE_PERIOD.end_dt based on EXPORT_LABOR.ts_schedule_cd and EXPORT_LABOR.year_no_cd and EXPORT_LABOR.period_no_cd End date of the period.

Converted to string yyyy-mm-dd.

WKEDBT CHAR (15) EXPORT_LABOR.batch_id Batch Number.
WKC5606TSD CHAR (10) EXPORT_LABOR.timesheet_dt The date associated with the timesheet.

Converted to string yyyy-mm-dd.

WKC5606SID CHAR (10) "01" The ID of the site ID from which the timesheet and employee came.
WKC5606CCD CHAR (10) EXPORT_LABOR.class_cd The current class to which the employee belongs.
WKC5606OTH CHAR (20) If EXPORT_LABOR.ot_fl = "Y," EXPORT_LABOR.hrs ; otherwise, 0.00. The number of overtime hours.

Converted to string.

WKC5606LDS CHAR (120) EXPORT_LABOR.line_desc Description of the charge on the line (Line Description).
WKC5606GRP CHAR (20) SPACES Group Code.
WKC5606CHG CHAR (45) EXPORT_LABOR.charge_cd Charge number for the timesheet line.
WKC5606CAI CHAR (20) SPACES Charge abbreviation code.
WKC5606UTL CHAR (10) SPACES Utilization code.
WKC5606T01 CHAR (30) EXPORT_LABOR.udt01_id The UDT01 identifier for the timesheet line (Proj/Task or Work Order).
WKC5606T02 CHAR (30) EXPORT_LABOR.udt02_id if not null; otherwise, spaces, The UDT02 identifier for the timesheet line.
WKC5606T03 CHAR (20) EXPORT_LABOR.udt03_id if not null; otherwise, spaces, The UDT03 identifier for the timesheet line.
WKC5606T04 CHAR (20) EXPORT_LABOR.udt04_id if not null; otherwise, spaces. The UDT04 identifier for the timesheet line.
WKC5606T05 CHAR (20) EXPORT_LABOR.udt05_id if not null; otherwise, spaces. The UDT05 identifier for the timesheet line.
WKC5606T06 CHAR (20) EXPORT_LABOR.udt06_id if not null; otherwise, spaces. The UDT06 identifier for the timesheet line (Job Step).
WKC5606T07 CHAR (20) EXPORT_LABOR.udt07_id if not null; otherwise, spaces. The UDT07 identifier for the timesheet line (Job Type).
WKC5606T08 CHAR (20) EXPORT_LABOR.udt08_id if not null; otherwise, spaces. The UDT08 identifier for the timesheet line.
WKC5606T09 CHAR (20) EXPORT_LABOR.udt09_id if not null; otherwise, spaces The UDT09 identifier for the timesheet line.
WKC5606T10 CHAR (20) EXPORT_LABOR.udt10_id The UDT10 identifier for the timesheet line (Pay Type).
WKC5606TST CHAR (254) EXPORT_LABOR.short_header_text if not null; otherwise, spaces. Timesheet Text.
WKC5606LBR CHAR (20) EXPORT_LABOR.rate1_amt/ EXPORT_LABOR.hrs The labor rate.
 Converted to string.
WKC5606LAM CHAR (20) EXPORT_LABOR.rate1_amt The labor amount.
 Converted to string.
WKC5606BRT CHAR (20) EXPORT_LABOR.rate2_amt/ EXPORT_LABOR.hrs The billing rate. 
 Converted to string.
WKC5606BAM CHAR (20) EXPORT_LABOR.rate2_amt The billing amount. 
 Converted to string.
WKC5606HRS CHAR (20) EXPORT_LABOR.hrs The entered labor hours for this cell.
WKC5606CRF CHAR (1) EXPORT_LABOR.correct_fl Logical as to whether this cell is a correcting entry.
WKC5606CTX CHAR (254) EXPORT_LABOR.short_cell_text if not null; otherwise, spaces. User-provided notes about the timesheet cell.
WKC5606LTX CHAR (254) EXPORT_LABOR.short_line_text if not null; otherwise, spaces. User-provided notes about the timesheet line.
WKC5606STS CHAR (1) "P" Status of the cell.
WKEDSP CHAR (1) "N" (EditSuccessfullyProcess) Logical as to whether this cell record has been confirmed.

"N" - Record has not been picked up.

"Y" - Record has been picked up.

WKC5606ETX CHAR (254) SPACES Error Text.
WKC5606ETK VARCHAR2 (50) EXPORT_LABOR.empl_id+ EXPORT_LABOR.ts_schedule_cd + EXPORT_LABOR.year_no_cd + EXPORT_LABOR.period_no_cd +

EXPORT_LABOR.hrs_dt

ET Key ID.

Padded with spaces to make fields full width.

WKUSER CHAR (10) Null User ID.
WKPID CHAR (10) Null Program ID.
WKJOBN CHAR (10) Null Workstation ID.
WKUPMJ NUMBER (6) Null Date - Updated.
WKUPMT NUMBER (6) Null Time - Updated.